package com.example.mapper.configuration;

import com.example.bean.configuration.PingGuXiangGuanLi;
import com.example.bean.configuration.vo.PingGuXiangGuanLiVo;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface PingGuXiangGuanLiMapper {

    List<PingGuXiangGuanLi> getpage(PingGuXiangGuanLiVo vo);

    Integer addpgxgl(PingGuXiangGuanLi pingGuXiangGuanLi);
    @Select("select * from pg_guanli where noid = #{aid}")
    PingGuXiangGuanLi getId(String aid);
    @Update("update pg_guanli set pg_name = #{pgname}, status = #{status}, miaoshu = #{miaoshu}, pg_leibie = #{pgleibie}, update_date = #{updatedate} where noid = #{noid}")
    Integer xiugai(PingGuXiangGuanLi pingGuXiangGuanLi);
    @Update("update pg_guanli set status = 0 where noid = #{noid}")
    Integer qidong(String noid);
    @Update("update pg_guanli set status = 1 where noid = #{noid}")
    Integer jinyong(String noid);

    Integer dels(List<String> ids);
}
